Systemstate Dump Analysis of Classical cases (part I)

In the preface, we invite Lao K, another Oracle expert from Zhongyi Technology, to share with you the classic cases of systemstate dump analysis. After that, we will have more technical experts to bring more sincerity to share. Lao K as a database project that has struggled in the data center for a long time.

2022-06-01 Database 我要分享

Parameter reminder that causes Oracle performance jitter

Preface unwittingly, the story of me and the data center in the technology life series has come to the fourth issue. Little y to see you again! When you see the following wavy tps curve in the business system stress test, how do you do it? What Xiao y (Zhongyi Technology) wants to share with you today is such a business system pressure.

2022-06-01 Database 我要分享

Technology Life Series the Story of me and the data Center (issue 4)-Parameter reminders that lead to Oracle performance jitter

Preface unwittingly, the story of me and the data center in the technology life series has come to the fourth issue. Little y to see you again! When you see the following wavy tps curve in the business system stress test, how do you do it? What Xiao y (Zhongyi Technology) wants to share with you today is such a business system pressure.

2022-06-01 Database 我要分享

Show engine innodb status interpretation

Show engine innodb status interpretation Note: the following is based on the personal understanding of the innodb status section of "High performance mysql third Edition" and "mysql Technology Insider innodb Storage engine". If there is any error,

2022-06-01 Database 我要分享

Db file scattered read

Db file scattered read 1: db file scattered read description 2: db file scattered read solution 3: db file scattered

2022-06-01 Database 我要分享

How to parse LINUX netstat connection state and perform TCP state transition

This article is about how to analyze the LINUX netstat connection state and TCP state transition, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article, without saying much, let's take a look at it with the editor. L

2022-06-01 Servers 我要分享

Matters needing attention when using wait () method and notify () method in Java

This article mainly talks about "precautions when using wait () method and notify () method in Java". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn the wait () method in Java.

2022-06-02 Internet Technology 我要分享

How to implement await and signal waiting / Notification Mechanism of Condition

Editor to share with you how to implement Condition's await and signal wait / notify mechanism. I hope you will get something after reading this article. Let's discuss it together. About 1.Condition any java object is natural

2022-06-02 Development 我要分享

Why does Waiting for table metadata lock appear in MySQL?

Editor, I would like to share with you why there is Waiting for table metadata lock in MySQL. I believe most people don't know much about it, so share this article for your reference. I hope you will learn a lot after reading this article.

2022-05-31 Database 我要分享

SQL*Net Wait Events

What is a Wait Event? During the normal functioning of a database, an Oracle process will occasional

2022-06-01 Database 我要分享

Oracle wait event (Wait Event): Sync ASM rebalance parsing

Summary: in the Oracle database, you can often see a special wait event: Sync ASM rebalance. The basic meaning of this wait event is to synchronize ASM rebalance changes in the cluster to make ASM changes in the set.

2022-06-01 Database 我要分享

Performance Diagnosis with AWR

Performance Diagnosis with Automatic Workload Repository (AWR) (Doc ID 1674086.1) In This Document1 P

2022-06-01 Database 我要分享

What are the problems and solutions of MySQL in concurrent scenarios

This article shows you the problems and solutions of MySQL in concurrent scenarios. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article. 1. The background is raised under the condition of multi-user concurrency for the database system.

2022-05-31 Database 我要分享

Percona monitors what several graphics of mysql look like.

This article shows you what the percona monitoring mysql graphics are like, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article. Several graphical explanations of percona monitoring mysql recently

2022-05-31 Database 我要分享

Analyze the problems and solutions under the concurrency of MySQL

1. Background for the database system, it has always been the goal of the database system to improve the concurrency under the condition of multi-user concurrency while ensuring the consistency of the data. not only to meet the needs of a large number of concurrent access, but also to ensure the security of data under this condition, in order to meet this goal, most databases use locks

2022-06-01 Database 我要分享

What are the parameters wait_timeout and interactive_timeout in MySQL and the implementation method of idle timeout

This article introduces the relevant knowledge of "what are the parameters wait_timeout and interactive_timeout in MySQL and the implementation of idle timeout". In the operation of practical cases, many people will encounter such a dilemma, and then let small

2022-05-31 Database 我要分享

The Heart of the Atoms, which has a Soviet animation built in, has been criticized for being suspected of racism

This article comes from Wechat's official account: game Research Society (ID:yysaag). The author: Zhaoyue was only criticized for the first time since the launch of the Heart of the Atom. The Heart of the Atomic depicts an overhead world line on which the Soviet Union has become more advanced than in history because of the rapid development of science and technology.

2023-11-24 IT Information 我要分享

Nadella responded to whether the Blizzard acquisition bypassed the British market: wait and see.

CTOnews.com May 17 news, Microsoft is trying to promote $69 billion acquisition of Activision Blizzard landed, the company's CEO Satya Nadella (Satya Nadella) in a recent interview, when asked whether to bypass some markets such as the UK

2023-11-24 IT Information 我要分享

How to start and terminate threads in Java

This article introduces how to start and terminate threads in Java, the content is very detailed, interested friends can refer to, hope to be helpful to you. In Java, we start a thread by calling the start () method in the Thread class, when the thread processes

2022-06-02 Internet Technology 我要分享

A collection of application examples | A comprehensive introduction to performance_schema

After the study of the previous six pages, I believe you have initially formed an overall understanding of what performance_schema is, but I think many of my colleagues may still look confused after reading the previous article. I will bring you performance_sc today.

2022-06-01 Database 我要分享